/**
 * 
 */
package com.estock.common.consts;

/**
 * @author richard
 *
 */
public class DaoQueryConsts {
	
	// Query parameters
	public static final String USERNAME = "username";
	public static final String PASSWORD = "password";
	
	public static final String ID = "id";
	public static final String WHO_CREATED = "WhoCreated";
	public static final String WHO_UPDATED = "WhoUpdated";
	public static final String DATE_CREATED = "DateCreated";
	public static final String DATE_UPDATED = "DateUpdated";
	
	public static final String STOCK_CODE = "code";
	public static final String STOCK_TYPE = "type";
	public static final String STOCK_ISSELFSELCT = "isSelfSelect";
	
	public static final String STOCKCATEGORY_NAME = "name";
	public static final String STOCKCATEGORY_ISACTIVE = "isActive";
	
	public static final String DAILYTRANS_CODE = "Code";
	public static final String DAILYTRANS_SDATE = "SDate";
	public static final String DAILYTRANS_OPENPRICE = "OpenPrice";
	public static final String DAILYTRANS_HIGHPRICE = "HighPrice";
	public static final String DAILYTRANS_LOWPRICE = "LowPrice";
	public static final String DAILYTRANS_CLOSEPRICE = "ClosePrice";
	public static final String DAILYTRANS_ADJCLOSEPRICE = "AdjClosePrice";
	public static final String DAILYTRANS_VOLUME = "Volume";
	
	
	// Named Query Consts
	public static final String getCategoriesByStockId = "StockCategory.getCategoriesByStockId";
	public static final String getStockNumByType = "Stock.getStockNumByType";
	public static final String getSelfSelectNum = "Stock.getSelfSelectNum";
	public static final String getIndexNum = "Index.getIndexNum";
	
	
	// native queries
	public static final String SP_UPDATE_LAST_TRANSDAY = "call estock.updateLastTransday()";
	
}
